[权限]单据数目对照表(11101019).sql 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281
  1. -- 功能权限
  2. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' )
  3. BEGIN
  4. UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',cSub_Id=N'SA',iGrade=N'2',cSupAuth_Id=N'SARPT',bEndGrade=N'0',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa'
  5. END
  6. ELSE
  7. BEGIN
  8. INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'SA',N'2',N'SARPT',N'0',N'77',NULL)
  9. END
  10. GO
  11. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' )
  12. BEGIN
  13. UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',cAuth_Name=N'单据数目对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa'
  14. END
  15. ELSE
  16. BEGIN
  17. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'单据数目对照表')
  18. END
  19. GO
  20. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' )
  21. BEGIN
  22. UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',cAuth_Name=N'单据数目对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa'
  23. END
  24. ELSE
  25. BEGIN
  26. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'单据数目对照表')
  27. END
  28. GO
  29. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa' )
  30. BEGIN
  31. UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',cAuth_Name=N'单据数目对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa'
  32. END
  33. ELSE
  34. BEGIN
  35. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'单据数目对照表')
  36. END
  37. GO
  38. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01' )
  39. BEGIN
  40. UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01'
  41. END
  42. ELSE
  43. BEGIN
  44. INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01',N'SA',N'3',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'1',N'77',NULL)
  45. END
  46. GO
  47. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01' )
  48. BEGIN
  49. UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01',cAuth_Name=N'Query:单据数目对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01'
  50. END
  51. ELSE
  52. BEGIN
  53. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01',N'Query:单据数目对照表')
  54. END
  55. GO
  56. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01' )
  57. BEGIN
  58. UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01',cAuth_Name=N'查询:单据数目对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01'
  59. END
  60. ELSE
  61. BEGIN
  62. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01',N'查询:单据数目对照表')
  63. END
  64. GO
  65. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01' )
  66. BEGIN
  67. UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01',cAuth_Name=N'查詢:单据数目对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01'
  68. END
  69. ELSE
  70. BEGIN
  71. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_01',N'查詢:单据数目对照表')
  72. END
  73. GO
  74. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02' )
  75. BEGIN
  76. UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02'
  77. END
  78. ELSE
  79. BEGIN
  80. INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02',N'SA',N'3',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'1',N'77',NULL)
  81. END
  82. GO
  83. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02' )
  84. BEGIN
  85. UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02',cAuth_Name=N'Configurat单据数目对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02'
  86. END
  87. ELSE
  88. BEGIN
  89. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02',N'Configurat单据数目对照表')
  90. END
  91. GO
  92. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02' )
  93. BEGIN
  94. UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02',cAuth_Name=N'设置:单据数目对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02'
  95. END
  96. ELSE
  97. BEGIN
  98. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02',N'设置:单据数目对照表')
  99. END
  100. GO
  101. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02' )
  102. BEGIN
  103. UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02',cAuth_Name=N'設置:单据数目对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02'
  104. END
  105. ELSE
  106. BEGIN
  107. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_02',N'設置:单据数目对照表')
  108. END
  109. GO
  110. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03' )
  111. BEGIN
  112. UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03'
  113. END
  114. ELSE
  115. BEGIN
  116. INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03',N'SA',N'3',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'1',N'77',NULL)
  117. END
  118. GO
  119. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03' )
  120. BEGIN
  121. UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03',cAuth_Name=N'Print:单据数目对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03'
  122. END
  123. ELSE
  124. BEGIN
  125. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03',N'Print:单据数目对照表')
  126. END
  127. GO
  128. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03' )
  129. BEGIN
  130. UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03',cAuth_Name=N'打印:单据数目对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03'
  131. END
  132. ELSE
  133. BEGIN
  134. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03',N'打印:单据数目对照表')
  135. END
  136. GO
  137. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03' )
  138. BEGIN
  139. UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03',cAuth_Name=N'列印:单据数目对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03'
  140. END
  141. ELSE
  142. BEGIN
  143. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_03',N'列印:单据数目对照表')
  144. END
  145. GO
  146. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04' )
  147. BEGIN
  148. UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04'
  149. END
  150. ELSE
  151. BEGIN
  152. INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04',N'SA',N'3',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'1',N'77',NULL)
  153. END
  154. GO
  155. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04' )
  156. BEGIN
  157. UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04',cAuth_Name=N'Output:单据数目对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04'
  158. END
  159. ELSE
  160. BEGIN
  161. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04',N'Output:单据数目对照表')
  162. END
  163. GO
  164. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04' )
  165. BEGIN
  166. UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04',cAuth_Name=N'输出:单据数目对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04'
  167. END
  168. ELSE
  169. BEGIN
  170. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04',N'输出:单据数目对照表')
  171. END
  172. GO
  173. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04' )
  174. BEGIN
  175. UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04',cAuth_Name=N'輸出:单据数目对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04'
  176. END
  177. ELSE
  178. BEGIN
  179. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_04',N'輸出:单据数目对照表')
  180. END
  181. GO
  182. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05' )
  183. BEGIN
  184. UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05'
  185. END
  186. ELSE
  187. BEGIN
  188. INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05',N'SA',N'3',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'1',N'77',NULL)
  189. END
  190. GO
  191. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05' )
  192. BEGIN
  193. UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05',cAuth_Name=N'Publish:单据数目对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05'
  194. END
  195. ELSE
  196. BEGIN
  197. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05',N'Publish:单据数目对照表')
  198. END
  199. GO
  200. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05' )
  201. BEGIN
  202. UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05',cAuth_Name=N'发布:单据数目对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05'
  203. END
  204. ELSE
  205. BEGIN
  206. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05',N'发布:单据数目对照表')
  207. END
  208. GO
  209. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05' )
  210. BEGIN
  211. UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05',cAuth_Name=N'發佈:单据数目对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05'
  212. END
  213. ELSE
  214. BEGIN
  215. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_05',N'發佈:单据数目对照表')
  216. END
  217. GO
  218. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b' )
  219. BEGIN
  220. UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b'
  221. END
  222. ELSE
  223. BEGIN
  224. INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b',N'SA',N'3',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa',N'1',N'77',NULL)
  225. END
  226. GO
  227. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b' )
  228. BEGIN
  229. UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b',cAuth_Name=N'View:单据数目对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b'
  230. END
  231. ELSE
  232. BEGIN
  233. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b',N'View:单据数目对照表')
  234. END
  235. GO
  236. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b' )
  237. BEGIN
  238. UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b',cAuth_Name=N'视图:单据数目对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b'
  239. END
  240. ELSE
  241. BEGIN
  242. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b',N'视图:单据数目对照表')
  243. END
  244. GO
  245. IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b' )
  246. BEGIN
  247. UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b',cAuth_Name=N'視圖:单据数目对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b'
  248. END
  249. ELSE
  250. BEGIN
  251. INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]b6179ec1-8741-48b0-983e-54a84c2920fa_6c420594-068c-4023-b76b-056729798c1b',N'視圖:单据数目对照表')
  252. END
  253. GO